Dataset info
| Number of variables | 59 |
|---|---|
| Number of observations | 109200 |
| Missing cells | 1007073 (15.6%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 190.6 MiB |
| Average record size in memory | 1.8 KiB |
Variables types
| CAT | 35 |
|---|---|
| NUM | 15 |
| BOOL | 8 |
| DATE | 1 |
Reproduction info
| Date of analysis | 2020-04-27 11:12:49.024998 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
Alternative_purchasing_group has 4291 (3.9%) missing values | Missing |
Alternative_purchasing_group has a high cardinality: 566 distinct values | Warning |
ATC has a high cardinality: 1124 distinct values | Warning |
Chemical_/_biological has 9190 (8.4%) missing values | Missing |
consumption has 8749 (8.0%) zeros | Zeros |
consumption_previous_year has 4354 (4.0%) zeros | Zeros |
Current_consumption has 9906 (9.1%) zeros | Zeros |
Dangerous_material_is_charged_with_a_permit has 96190 (88.1%) missing values | Missing |
dangerous_substance has 96189 (88.1%) missing values | Missing |
Date_of_basket_entry has 49905 (45.7%) missing values | Missing |
Date_of_basket_entry has a high cardinality: 55 distinct values | Warning |
Description_Alternative_purchasing_group has 4291 (3.9%) missing values | Missing |
Description_Alternative_purchasing_group has a high cardinality: 566 distinct values | Warning |
Description_outline has 8322 (7.6%) missing values | Missing |
Description_outline has a high cardinality: 307 distinct values | Warning |
European_patent_expires has 107645 (98.6%) missing values | Missing |
For_adults has 104554 (95.7%) missing values | Missing |
Form_of_giving has 64017 (58.6%) missing values | Missing |
GENERY_FATHER has 64846 (59.4%) missing values | Missing |
GENERY_FATHER has a high cardinality: 686 distinct values | Warning |
Inventory has 12220 (11.2%) zeros | Zeros |
Inventory_of_consumption_months is highly skewed (γ1 = 84.76938652) | Skewed |
Inventory_of_consumption_months has 12700 (11.6%) zeros | Zeros |
Main_outline has 8322 (7.6%) missing values | Missing |
Main_outline has a high cardinality: 307 distinct values | Warning |
Narcotic_/_psychotropic has 49980 (45.8%) missing values | Missing |
Narcotic_/_psychotropic has 55580 (50.9%) zeros | Zeros |
Plant has constant value "7350.0" | Rejected |
Prediction has 10520 (9.6%) zeros | Zeros |
PRICE is highly skewed (γ1 = 24.26847489) | Skewed |
Price_for_absolute_packaging has 1632 (1.5%) zeros | Zeros |
Quantity_in_absolute_packaging has 1631 (1.5%) zeros | Zeros |
Quantity_in_Packaging-Absolute has 1467 (1.3%) missing values | Missing |
Quantity_in_packing-relative has 3430 (3.1%) missing values | Missing |
Quantity_in_packing-relative has 73588 (67.4%) zeros | Zeros |
Safety_Stock has 11178 (10.2%) zeros | Zeros |
Send_code_to_Omri has constant value "1.0" | Rejected |
Serving_form has 9531 (8.7%) missing values | Missing |
Serving_form has a high cardinality: 53 distinct values | Warning |
skucode2 has a high cardinality: 3281 distinct values | Warning |
status has constant value "1.0" | Rejected |
Toxic_item has 8884 (8.1%) missing values | Missing |
type_of_packeging has 102708 (94.1%) missing values | Missing |
U#S#_Patent_Expires has 107330 (98.3%) missing values | Missing |
Validity_of_Ministry_of_Health_registration has 103787 (95.0%) missing values | Missing |
Validity_of_Ministry_of_Health_registration has a high cardinality: 83 distinct values | Warning |
VENDOR has a high cardinality: 155 distinct values | Warning |
consumption_previous_year is highly correlated with consumption and 2 other fields | High Correlation |
consumption is highly correlated with consumption_previous_year and 2 other fields | High Correlation |
Current_consumption is highly correlated with consumption and 2 other fields | High Correlation |
Prediction is highly correlated with consumption and 2 other fields | High Correlation |
Quantity_in_Packaging-Absolute is highly correlated with Quantity_in_absolute_packaging | High Correlation |
Quantity_in_absolute_packaging is highly correlated with Quantity_in_Packaging-Absolute | High Correlation |
Safety_Stock is highly correlated with Inventory | High Correlation |
Inventory is highly correlated with Safety_Stock | High Correlation |
A_group_of_materials
Categorical
| Distinct count | 38 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 20190 | |
|---|---|
| 20100 | |
| 20120 | |
| 20130 | 9307 |
| 20210 | 7186 |
| Other values (33) |
| Value | Count | Frequency (%) | |
| 20190 | 17706 | 16.2% | |
| 20100 | 13499 | 12.4% | |
| 20120 | 11289 | 10.3% | |
| 20130 | 9307 | 8.5% | |
| 20210 | 7186 | 6.6% | |
| 20140 | 6236 | 5.7% | |
| 20270 | 5181 | 4.7% | |
| 20220 | 4568 | 4.2% | |
| 20180 | 4468 | 4.1% | |
| 20110 | 3636 | 3.3% | |
| Other values (28) | 26124 | 23.9% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 5 |
|---|---|
| Mean length | 4.995924908 |
| Min length | 4 |
ABC
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| C | |
|---|---|
| B | |
| A |
| Value | Count | Frequency (%) | |
| C | 59649 | 54.6% | |
| B | 36448 | 33.4% | |
| A | 13103 | 12.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
Affiliation_Group
Categorical
| Distinct count | 39 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 187 |
| Missing (%) | 0.2% |
| Memory size | 853.2 KiB |
| 20 | |
|---|---|
| 11 | |
| 13 | |
| 24 | |
| 14 | |
| Other values (33) |
| Value | Count | Frequency (%) | |
| 20 | 17446 | 16.0% | |
| 11 | 13890 | 12.7% | |
| 13 | 11552 | 10.6% | |
| 24 | 10966 | 10.0% | |
| 14 | 9608 | 8.8% | |
| 21 | 7346 | 6.7% | |
| 15 | 6314 | 5.8% | |
| 22 | 4891 | 4.5% | |
| 19 | 4767 | 4.4% | |
| 17 | 3448 | 3.2% | |
| Other values (28) | 18785 | 17.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.003424908 |
| Min length | 2 |
| Distinct count | 566 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 4291 |
| Missing (%) | 3.9% |
| Memory size | 853.2 KiB |
| 1734 | 3548 |
|---|---|
| 1591 | 2260 |
| 1875 | 2037 |
| 1068 | 1817 |
| 1823 | 1622 |
| Other values (560) |
| Value | Count | Frequency (%) | |
| 1734 | 3548 | 3.2% | |
| 1591 | 2260 | 2.1% | |
| 1875 | 2037 | 1.9% | |
| 1068 | 1817 | 1.7% | |
| 1823 | 1622 | 1.5% | |
| 1317 | 1570 | 1.4% | |
| 1053 | 1466 | 1.3% | |
| 1642 | 1231 | 1.1% | |
| 1027 | 1161 | 1.1% | |
| 1354 | 1130 | 1.0% | |
| Other values (555) | 87067 | 79.7% | |
| (Missing) | 4291 | 3.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Distinct count | 1124 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 1/0/1900 | 8221 |
|---|---|
| ATC: | 1317 |
| ATC:M01AE01 | 1068 |
| ATC:N03AX16 | 763 |
| ATC:C10AA07 | 745 |
| Other values (1119) |
| Value | Count | Frequency (%) | |
| 1/0/1900 | 8221 | 7.5% | |
| ATC: | 1317 | 1.2% | |
| ATC:M01AE01 | 1068 | 1.0% | |
| ATC:N03AX16 | 763 | 0.7% | |
| ATC:C10AA07 | 745 | 0.7% | |
| ATC:A11AA06 | 731 | 0.7% | |
| ATC:C10AA05 | 731 | 0.7% | |
| ATC:N06BA04 | 711 | 0.7% | |
| ATC:A11CC05 | 659 | 0.6% | |
| ATC:A07FA01 | 639 | 0.6% | |
| Other values (1114) | 93615 | 85.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 11 |
|---|---|
| Mean length | 10.52885531 |
| Min length | 4 |
Basic_unit_of_measure
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| EA | |
|---|---|
| PAC | 17403 |
| KIT | 386 |
| BLS | 29 |
| BT | 27 |
| Value | Count | Frequency (%) | |
| EA | 91354 | 83.7% | |
| PAC | 17403 | 15.9% | |
| KIT | 386 | 0.4% | |
| BLS | 29 | < 0.1% | |
| BT | 27 | < 0.1% | |
| KG | 1 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 3 |
|---|---|
| Mean length | 2.163168498 |
| Min length | 2 |
Budget_Group
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| B | |
|---|---|
| E | |
| A | |
| D | 6715 |
| H | 135 |
| Value | Count | Frequency (%) | |
| B | 51894 | 47.5% | |
| E | 27954 | 25.6% | |
| A | 22502 | 20.6% | |
| D | 6715 | 6.1% | |
| H | 135 | 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 9190 |
| Missing (%) | 8.4% |
| Memory size | 853.2 KiB |
| 1 | |
|---|---|
| 2 | 3606 |
| Value | Count | Frequency (%) | |
| 1 | 96404 | 88.3% | |
| 2 | 3606 | 3.3% | |
| (Missing) | 9190 | 8.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
chronic
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 560 |
| Missing (%) | 0.5% |
| Memory size | 853.2 KiB |
| 0 | |
|---|---|
| 1 | |
| (Missing) | 560 |
| Value | Count | Frequency (%) | |
| 0 | 61792 | 56.6% | |
| 1 | 46848 | 42.9% | |
| (Missing) | 560 | 0.5% |
Consumer_management
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 853.2 KiB |
| ave | |
|---|---|
| pred |
| Value | Count | Frequency (%) | |
| ave | 90097 | 82.5% | |
| pred | 19102 | 17.5% | |
| (Missing) | 1 | < 0.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.174935897 |
| Min length | 3 |
| Distinct count | 2259 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77895.93857 |
|---|---|
| Minimum | 0.0 |
| Maximum | 4392300.0 |
| Zeros | 8749 |
| Zeros (%) | 8.0% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 836 |
| median | 4720 |
| Q3 | 47377.5 |
| 95-th percentile | 376105 |
| Maximum | 4392300 |
| Range | 4392300 |
| Interquartile range (IQR) | 46541.5 |
Descriptive statistics
| Standard deviation | 244982.8421 |
|---|---|
| Coefficient of variation (CV) | 3.14500148 |
| Kurtosis | 107.3862214 |
| Mean | 77895.93857 |
| Median Absolute Deviation (MAD) | 107843.0769 |
| Skewness | 8.442353745 |
| Sum | 8506236492 |
| Variance | 6.001659294e+10 |
| Value | Count | Frequency (%) | |
| 0 | 8749 | 8.0% | |
| 1025 | 163 | 0.1% | |
| 1097 | 151 | 0.1% | |
| 2427 | 145 | 0.1% | |
| 384 | 144 | 0.1% | |
| 678 | 144 | 0.1% | |
| 27290 | 144 | 0.1% | |
| 5688 | 141 | 0.1% | |
| 136200 | 136 | 0.1% | |
| 1177 | 133 | 0.1% | |
| Other values (2249) | 99150 | 90.8% |
| Value | Count | Frequency (%) | |
| 0 | 8749 | 8.0% | |
| 1 | 32 | < 0.1% | |
| 2 | 20 | < 0.1% | |
| 3 | 21 | < 0.1% | |
| 5 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4392300 | 72 | 0.1% | |
| 3318000 | 72 | 0.1% | |
| 3239610 | 72 | 0.1% | |
| 1633120 | 72 | 0.1% | |
| 1590350 | 72 | 0.1% |
| Distinct count | 2806 |
|---|---|
| Unique (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 885070.1067 |
|---|---|
| Minimum | 0.0 |
| Maximum | 46044870.0 |
| Zeros | 4354 |
| Zeros (%) | 4.0% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 844.45 |
| Q1 | 11172 |
| median | 61332 |
| Q3 | 583110 |
| 95-th percentile | 4533600 |
| Maximum | 46044870 |
| Range | 46044870 |
| Interquartile range (IQR) | 571938 |
Descriptive statistics
| Standard deviation | 2696712.997 |
|---|---|
| Coefficient of variation (CV) | 3.046891966 |
| Kurtosis | 98.64178706 |
| Mean | 885070.1067 |
| Median Absolute Deviation (MAD) | 1205272.079 |
| Skewness | 8.117374417 |
| Sum | 9.664965565e+10 |
| Variance | 7.27226099e+12 |
| Value | Count | Frequency (%) | |
| 0 | 4354 | 4.0% | |
| 12687 | 128 | 0.1% | |
| 9622 | 110 | 0.1% | |
| 11371 | 105 | 0.1% | |
| 17716 | 103 | 0.1% | |
| 5770 | 101 | 0.1% | |
| 4532 | 98 | 0.1% | |
| 454770 | 92 | 0.1% | |
| 3530 | 85 | 0.1% | |
| 35771040 | 72 | 0.1% | |
| Other values (2796) | 103952 | 95.2% |
| Value | Count | Frequency (%) | |
| 0 | 4354 | 4.0% | |
| 1 | 67 | 0.1% | |
| 3 | 4 | < 0.1% | |
| 10 | 58 | 0.1% | |
| 13 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 46044870 | 72 | 0.1% | |
| 37611900 | 72 | 0.1% | |
| 35771040 | 72 | 0.1% | |
| 19037280 | 72 | 0.1% | |
| 16971570 | 72 | 0.1% |
| Distinct count | 2243 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103728.2482 |
|---|---|
| Minimum | 0.0 |
| Maximum | 5666490.0 |
| Zeros | 9906 |
| Zeros (%) | 9.1% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 982 |
| median | 5879 |
| Q3 | 62790 |
| 95-th percentile | 520530 |
| Maximum | 5666490 |
| Range | 5666490 |
| Interquartile range (IQR) | 61808 |
Descriptive statistics
| Standard deviation | 321749.018 |
|---|---|
| Coefficient of variation (CV) | 3.101845674 |
| Kurtosis | 101.8774158 |
| Mean | 103728.2482 |
| Median Absolute Deviation (MAD) | 143777.058 |
| Skewness | 8.188974489 |
| Sum | 1.13271247e+10 |
| Variance | 1.035224306e+11 |
| Value | Count | Frequency (%) | |
| 0 | 9906 | 9.1% | |
| 1023 | 182 | 0.2% | |
| 3355 | 182 | 0.2% | |
| 602 | 177 | 0.2% | |
| 120 | 175 | 0.2% | |
| 180 | 162 | 0.1% | |
| 763 | 157 | 0.1% | |
| 722 | 143 | 0.1% | |
| 1401 | 142 | 0.1% | |
| 3814 | 141 | 0.1% | |
| Other values (2233) | 97833 | 89.6% |
| Value | Count | Frequency (%) | |
| 0 | 9906 | 9.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 93 | 0.1% | |
| 3 | 32 | < 0.1% | |
| 4 | 13 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5666490 | 72 | 0.1% | |
| 4368000 | 72 | 0.1% | |
| 4218780 | 72 | 0.1% | |
| 2010420 | 72 | 0.1% | |
| 1938600 | 72 | 0.1% |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 96190 |
| Missing (%) | 88.1% |
| Memory size | 853.2 KiB |
| 0 | |
|---|---|
| 1 | 399 |
| Value | Count | Frequency (%) | |
| 0 | 12611 | 11.5% | |
| 1 | 399 | 0.4% | |
| (Missing) | 96190 | 88.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.642582418 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 96189 |
| Missing (%) | 88.1% |
| Memory size | 853.2 KiB |
| 0 | |
|---|---|
| 1 | 769 |
| Value | Count | Frequency (%) | |
| 0 | 12242 | 11.2% | |
| 1 | 769 | 0.7% | |
| (Missing) | 96189 | 88.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.642554945 |
| Min length | 1 |
| Distinct count | 55 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 49905 |
| Missing (%) | 45.7% |
| Memory size | 853.2 KiB |
| 01.01.1995 | |
|---|---|
| 01.01.2000 | 5139 |
| 01.03.2001 | 3979 |
| 01.03.1999 | 3303 |
| 01.03.2002 | 2525 |
| Other values (49) |
| Value | Count | Frequency (%) | |
| 01.01.1995 | 28502 | 26.1% | |
| 01.01.2000 | 5139 | 4.7% | |
| 01.03.2001 | 3979 | 3.6% | |
| 01.03.1999 | 3303 | 3.0% | |
| 01.03.2002 | 2525 | 2.3% | |
| 01.01.2009 | 1691 | 1.5% | |
| 01.05.2006 | 1669 | 1.5% | |
| 01.03.2008 | 1272 | 1.2% | |
| 15.01.2015 | 1016 | 0.9% | |
| 01.01.2010 | 963 | 0.9% | |
| Other values (44) | 9236 | 8.5% | |
| (Missing) | 49905 | 45.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 7.257967033 |
| Min length | 4 |
| Distinct count | 566 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 4291 |
| Missing (%) | 3.9% |
| Memory size | 853.2 KiB |
| Hypertension | 3548 |
|---|---|
| Bact.Inf., Sys. | 2260 |
| Statines | 2037 |
| EPILEPSY- Anticonvulsants | 1817 |
| Pain, Mod/Sev | 1622 |
| Other values (560) |
| Value | Count | Frequency (%) | |
| Hypertension | 3548 | 3.2% | |
| Bact.Inf., Sys. | 2260 | 2.1% | |
| Statines | 2037 | 1.9% | |
| EPILEPSY- Anticonvulsants | 1817 | 1.7% | |
| Pain, Mod/Sev | 1622 | 1.5% | |
| הורדת חום ושיכוך כאב | 1570 | 1.4% | |
| Depression-SSRI | 1466 | 1.3% | |
| Diabetes Mell. | 1231 | 1.1% | |
| BPH | 1161 | 1.1% | |
| טיפול אנטי פטרייתי | 1130 | 1.0% | |
| Other values (555) | 87067 | 79.7% | |
| (Missing) | 4291 | 3.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 30 |
|---|---|
| Mean length | 15.21119963 |
| Min length | 2 |
| Distinct count | 307 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 8322 |
| Missing (%) | 7.6% |
| Memory size | 853.2 KiB |
| Hypertension | 3810 |
|---|---|
| Diabetes Mell. | 3613 |
| food adittive | 3037 |
| Not Designated | 2813 |
| Epilepsy | 2436 |
| Other values (301) |
| Value | Count | Frequency (%) | |
| Hypertension | 3810 | 3.5% | |
| Diabetes Mell. | 3613 | 3.3% | |
| food adittive | 3037 | 2.8% | |
| Not Designated | 2813 | 2.6% | |
| Epilepsy | 2436 | 2.2% | |
| cosmetics | 2290 | 2.1% | |
| Bact.Inf., Sys. | 2264 | 2.1% | |
| Statines | 2037 | 1.9% | |
| Antidepressants | 2008 | 1.8% | |
| Pain, Mild/Mod. | 1927 | 1.8% | |
| Other values (296) | 74643 | 68.4% | |
| (Missing) | 8322 | 7.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 30 |
|---|---|
| Mean length | 11.98589744 |
| Min length | 3 |
| Distinct count | 902 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| Minimum | 2006-03-06 00:00:00 |
|---|---|
| Maximum | 2019-11-20 00:00:00 |
| Distinct count | 31 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 107645 |
| Missing (%) | 98.6% |
| Memory size | 853.2 KiB |
| 01.02.2015 | |
|---|---|
| 01.06.2017 | 121 |
| 01.03.2016 | 120 |
| 01.10.2018 | 114 |
| 01.03.2017 | 98 |
| Other values (25) |
| Value | Count | Frequency (%) | |
| 01.02.2015 | 199 | 0.2% | |
| 01.06.2017 | 121 | 0.1% | |
| 01.03.2016 | 120 | 0.1% | |
| 01.10.2018 | 114 | 0.1% | |
| 01.03.2017 | 98 | 0.1% | |
| 01.09.2019 | 78 | 0.1% | |
| 01.12.2022 | 74 | 0.1% | |
| 01.05.2020 | 72 | 0.1% | |
| 01.07.2018 | 72 | 0.1% | |
| 01.05.2019 | 64 | 0.1% | |
| Other values (20) | 543 | 0.5% | |
| (Missing) | 107645 | 98.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.08543956 |
| Min length | 4 |
Exceptional_policy
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 0 | |
|---|---|
| 1 | 11625 |
| Value | Count | Frequency (%) | |
| 0 | 97575 | 89.4% | |
| 1 | 11625 | 10.6% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 104554 |
| Missing (%) | 95.7% |
| Memory size | 853.2 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 4646 | 4.3% | |
| (Missing) | 104554 | 95.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.872362637 |
| Min length | 1 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 64017 |
| Missing (%) | 58.6% |
| Memory size | 853.2 KiB |
| 0 | |
|---|---|
| 17 | 25 |
| 15 | 6 |
| Value | Count | Frequency (%) | |
| 0 | 45152 | 41.3% | |
| 17 | 25 | < 0.1% | |
| 15 | 6 | < 0.1% | |
| (Missing) | 64017 | 58.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.758992674 |
| Min length | 1 |
General_purpose
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 0 | |
|---|---|
| 6 | 1013 |
| 2 | 457 |
| 1 | 246 |
| Value | Count | Frequency (%) | |
| 0 | 107484 | 98.4% | |
| 6 | 1013 | 0.9% | |
| 2 | 457 | 0.4% | |
| 1 | 246 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 686 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 64846 |
| Missing (%) | 59.4% |
| Memory size | 853.2 KiB |
| 3999001541 | 220 |
|---|---|
| 3999001291 | 215 |
| 3999019172 | 211 |
| 3999001511 | 209 |
| 3999001491 | 208 |
| Other values (680) |
| Value | Count | Frequency (%) | |
| 3999001541 | 220 | 0.2% | |
| 3999001291 | 215 | 0.2% | |
| 3999019172 | 211 | 0.2% | |
| 3999001511 | 209 | 0.2% | |
| 3999001491 | 208 | 0.2% | |
| 3999001150 | 206 | 0.2% | |
| 3999001490 | 205 | 0.2% | |
| 3999003522 | 203 | 0.2% | |
| 3999001280 | 200 | 0.2% | |
| 3999001542 | 199 | 0.2% | |
| Other values (675) | 42278 | 38.7% | |
| (Missing) | 64846 | 59.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 10 |
|---|---|
| Mean length | 6.437032967 |
| Min length | 4 |
| Distinct count | 2289 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103812.7952 |
|---|---|
| Minimum | 0.0 |
| Maximum | 6462780.0 |
| Zeros | 12220 |
| Zeros (%) | 11.2% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1261 |
| median | 5710 |
| Q3 | 65750 |
| 95-th percentile | 484350 |
| Maximum | 6462780 |
| Range | 6462780 |
| Interquartile range (IQR) | 64489 |
Descriptive statistics
| Standard deviation | 361671.6745 |
|---|---|
| Coefficient of variation (CV) | 3.483883406 |
| Kurtosis | 134.8190112 |
| Mean | 103812.7952 |
| Median Absolute Deviation (MAD) | 144291.345 |
| Skewness | 9.639427544 |
| Sum | 1.133635723e+10 |
| Variance | 1.308064001e+11 |
| Value | Count | Frequency (%) | |
| 0 | 12220 | 11.2% | |
| 875 | 156 | 0.1% | |
| 6647 | 144 | 0.1% | |
| 400 | 144 | 0.1% | |
| 5258 | 144 | 0.1% | |
| 7306 | 143 | 0.1% | |
| 41412 | 140 | 0.1% | |
| 2208 | 139 | 0.1% | |
| 74370 | 137 | 0.1% | |
| 88620 | 136 | 0.1% | |
| Other values (2279) | 95697 | 87.6% |
| Value | Count | Frequency (%) | |
| 0 | 12220 | 11.2% | |
| 2 | 11 | < 0.1% | |
| 5 | 71 | 0.1% | |
| 6 | 40 | < 0.1% | |
| 7 | 13 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6462780 | 72 | 0.1% | |
| 6338010 | 72 | 0.1% | |
| 3606000 | 72 | 0.1% | |
| 2664180 | 72 | 0.1% | |
| 2465100 | 72 | 0.1% |
| Distinct count | 530 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.764411447 |
|---|---|
| Minimum | 0.0 |
| Maximum | 786.67 |
| Zeros | 12700 |
| Zeros (%) | 11.6% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.75 |
| median | 1.36 |
| Q3 | 2.19 |
| 95-th percentile | 3.63 |
| Maximum | 786.67 |
| Range | 786.67 |
| Interquartile range (IQR) | 1.44 |
Descriptive statistics
| Standard deviation | 7.255484096 |
|---|---|
| Coefficient of variation (CV) | 4.112127083 |
| Kurtosis | 8850.945007 |
| Mean | 1.764411447 |
| Median Absolute Deviation (MAD) | 1.155885864 |
| Skewness | 84.76938652 |
| Sum | 192673.73 |
| Variance | 52.64204947 |
| Value | Count | Frequency (%) | |
| 0 | 12700 | 11.6% | |
| 0.73 | 973 | 0.9% | |
| 0.93 | 882 | 0.8% | |
| 0.75 | 808 | 0.7% | |
| 0.9 | 754 | 0.7% | |
| 1.53 | 753 | 0.7% | |
| 0.69 | 735 | 0.7% | |
| 0.83 | 734 | 0.7% | |
| 1.07 | 729 | 0.7% | |
| 1.11 | 692 | 0.6% | |
| Other values (520) | 89440 | 81.9% |
| Value | Count | Frequency (%) | |
| 0 | 12700 | 11.6% | |
| 0.01 | 101 | 0.1% | |
| 0.02 | 98 | 0.1% | |
| 0.03 | 25 | < 0.1% | |
| 0.05 | 63 | 0.1% |
| Value | Count | Frequency (%) | |
| 786.67 | 7 | < 0.1% | |
| 255.13 | 2 | < 0.1% | |
| 145.76 | 21 | < 0.1% | |
| 109.8 | 16 | < 0.1% | |
| 98.52 | 24 | < 0.1% |
Item_in_health_basket
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 190 |
| Missing (%) | 0.2% |
| Memory size | 853.2 KiB |
| 1 | |
|---|---|
| 0 | |
| (Missing) | 190 |
| Value | Count | Frequency (%) | |
| 1 | 67552 | 61.9% | |
| 0 | 41458 | 38.0% | |
| (Missing) | 190 | 0.2% |
Item_Type
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 483 |
| Missing (%) | 0.4% |
| Memory size | 853.2 KiB |
| 0 | |
|---|---|
| 1 | 309 |
| 6 | 74 |
| 3 | 72 |
| Value | Count | Frequency (%) | |
| 0 | 108262 | 99.1% | |
| 1 | 309 | 0.3% | |
| 6 | 74 | 0.1% | |
| 3 | 72 | 0.1% | |
| (Missing) | 483 | 0.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
Loading_group
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 23 | |
|---|---|
| 11 | 4007 |
| 25 | 3439 |
| 13 | 2058 |
| 24 | 1450 |
| Other values (9) | 3435 |
| Value | Count | Frequency (%) | |
| 23 | 94811 | 86.8% | |
| 11 | 4007 | 3.7% | |
| 25 | 3439 | 3.1% | |
| 13 | 2058 | 1.9% | |
| 24 | 1450 | 1.3% | |
| 12 | 1002 | 0.9% | |
| 22 | 908 | 0.8% | |
| 15 | 711 | 0.7% | |
| 14 | 398 | 0.4% | |
| 19 | 246 | 0.2% | |
| Other values (4) | 170 | 0.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 2 |
|---|---|
| Mean length | 1.998525641 |
| Min length | 1 |
| Distinct count | 307 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 8322 |
| Missing (%) | 7.6% |
| Memory size | 853.2 KiB |
| 13 | 3810 |
|---|---|
| 12 | 3613 |
| 393 | 3037 |
| 0 | 2813 |
| 14 | 2436 |
| Other values (301) |
| Value | Count | Frequency (%) | |
| 13 | 3810 | 3.5% | |
| 12 | 3613 | 3.3% | |
| 393 | 3037 | 2.8% | |
| 0 | 2813 | 2.6% | |
| 14 | 2436 | 2.2% | |
| 392 | 2290 | 2.1% | |
| 60 | 2264 | 2.1% | |
| 432 | 2037 | 1.9% | |
| 420 | 2008 | 1.8% | |
| 54 | 1927 | 1.8% | |
| Other values (296) | 74643 | 68.4% | |
| (Missing) | 8322 | 7.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 2.558763736 |
| Min length | 1 |
Material_Type
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| ZHW1 | |
|---|---|
| ZHW3 | 8076 |
| ZUB1 | 305 |
| Value | Count | Frequency (%) | |
| ZHW1 | 100819 | 92.3% | |
| ZHW3 | 8076 | 7.4% | |
| ZUB1 | 305 | 0.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
month_year
Categorical
| Distinct count | 36 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 12/2019 | 3210 |
|---|---|
| 07/2018 | 3186 |
| 01/2019 | 3150 |
| 12/2018 | 3140 |
| 08/2018 | 3131 |
| Other values (31) |
| Value | Count | Frequency (%) | |
| 12/2019 | 3210 | 2.9% | |
| 07/2018 | 3186 | 2.9% | |
| 01/2019 | 3150 | 2.9% | |
| 12/2018 | 3140 | 2.9% | |
| 08/2018 | 3131 | 2.9% | |
| 10/2018 | 3127 | 2.9% | |
| 07/2019 | 3114 | 2.9% | |
| 01/2018 | 3107 | 2.8% | |
| 11/2019 | 3106 | 2.8% | |
| 10/2017 | 3087 | 2.8% | |
| Other values (26) | 77842 | 71.3% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 7 |
|---|---|
| Mean length | 7 |
| Min length | 7 |
Must_prescribe
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 68 |
| Missing (%) | 0.1% |
| Memory size | 853.2 KiB |
| 1 | |
|---|---|
| 0 | |
| (Missing) | 68 |
| Value | Count | Frequency (%) | |
| 1 | 68982 | 63.2% | |
| 0 | 40150 | 36.8% | |
| (Missing) | 68 | 0.1% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 49980 |
| Missing (%) | 45.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1018574806 |
|---|---|
| Minimum | 0.0 |
| Maximum | 5.0 |
| Zeros | 55580 |
| Zeros (%) | 50.9% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4596484669 |
|---|---|
| Coefficient of variation (CV) | 4.512662834 |
| Kurtosis | 39.88497193 |
| Mean | 0.1018574806 |
| Median Absolute Deviation (MAD) | 0.1911934742 |
| Skewness | 5.758947642 |
| Sum | 6032 |
| Variance | 0.2112767132 |
| Value | Count | Frequency (%) | |
| 0 | 55580 | 50.9% | |
| 1 | 2058 | 1.9% | |
| 2 | 1002 | 0.9% | |
| 3 | 465 | 0.4% | |
| 5 | 115 | 0.1% | |
| (Missing) | 49980 | 45.8% |
| Value | Count | Frequency (%) | |
| 0 | 55580 | 50.9% | |
| 1 | 2058 | 1.9% | |
| 2 | 1002 | 0.9% | |
| 3 | 465 | 0.4% | |
| 5 | 115 | 0.1% |
| Value | Count | Frequency (%) | |
| 5 | 115 | 0.1% | |
| 3 | 465 | 0.4% | |
| 2 | 1002 | 0.9% | |
| 1 | 2058 | 1.9% | |
| 0 | 55580 | 50.9% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 7350 |
|---|
| Value | Count | Frequency (%) | |
| 7350 | 109200 | 100.0% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Distinct count | 2189 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 74872.72531 |
|---|---|
| Minimum | 0.0 |
| Maximum | 4302782.0 |
| Zeros | 10520 |
| Zeros (%) | 9.6% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 754 |
| median | 4390 |
| Q3 | 46016 |
| 95-th percentile | 364336 |
| Maximum | 4302782 |
| Range | 4302782 |
| Interquartile range (IQR) | 45262 |
Descriptive statistics
| Standard deviation | 232804.2894 |
|---|---|
| Coefficient of variation (CV) | 3.109333718 |
| Kurtosis | 110.3154294 |
| Mean | 74872.72531 |
| Median Absolute Deviation (MAD) | 103632.2149 |
| Skewness | 8.466796196 |
| Sum | 8176101604 |
| Variance | 5.419783715e+10 |
| Value | Count | Frequency (%) | |
| 0 | 10520 | 9.6% | |
| 627 | 193 | 0.2% | |
| 465 | 172 | 0.2% | |
| 1466 | 169 | 0.2% | |
| 1294 | 164 | 0.2% | |
| 471 | 155 | 0.1% | |
| 598 | 154 | 0.1% | |
| 3785 | 144 | 0.1% | |
| 6903 | 144 | 0.1% | |
| 4855 | 144 | 0.1% | |
| Other values (2179) | 97241 | 89.0% |
| Value | Count | Frequency (%) | |
| 0 | 10520 | 9.6% | |
| 1 | 2 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4302782 | 72 | 0.1% | |
| 3093749 | 72 | 0.1% | |
| 2913005 | 72 | 0.1% | |
| 1601720 | 72 | 0.1% | |
| 1553512 | 72 | 0.1% |
| Distinct count | 1485 |
|---|---|
| Unique (%) | 1.4% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.4995585 |
|---|---|
| Minimum | 0.0 |
| Maximum | 13106.76 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.14 |
| Q1 | 0.49 |
| median | 4.84 |
| Q3 | 16.45 |
| 95-th percentile | 79.56 |
| Maximum | 13106.76 |
| Range | 13106.76 |
| Interquartile range (IQR) | 15.96 |
Descriptive statistics
| Standard deviation | 336.7350527 |
|---|---|
| Coefficient of variation (CV) | 8.11418398 |
| Kurtosis | 764.5607774 |
| Mean | 41.4995585 |
| Median Absolute Deviation (MAD) | 60.93345883 |
| Skewness | 24.26847489 |
| Sum | 4531544.29 |
| Variance | 113390.4957 |
| Value | Count | Frequency (%) | |
| 0.14 | 1361 | 1.2% | |
| 0.16 | 1058 | 1.0% | |
| 0.2 | 1053 | 1.0% | |
| 0.15 | 1050 | 1.0% | |
| 0.33 | 1042 | 1.0% | |
| 0.29 | 1022 | 0.9% | |
| 0.11 | 1018 | 0.9% | |
| 0.51 | 907 | 0.8% | |
| 11.7 | 891 | 0.8% | |
| 0.1 | 861 | 0.8% | |
| Other values (1474) | 98932 | 90.6% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 0.01 | 207 | 0.2% | |
| 0.03 | 232 | 0.2% | |
| 0.04 | 180 | 0.2% | |
| 0.05 | 250 | 0.2% |
| Value | Count | Frequency (%) | |
| 13106.76 | 2 | < 0.1% | |
| 12471.82 | 35 | < 0.1% | |
| 10466.91 | 4 | < 0.1% | |
| 9371.7 | 5 | < 0.1% | |
| 8226.27 | 3 | < 0.1% |
| Distinct count | 1917 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 310.5627059 |
|---|---|
| Minimum | 0.0 |
| Maximum | 49409.36 |
| Zeros | 1632 |
| Zeros (%) | 1.5% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.2 |
| Q1 | 7.6 |
| median | 16.38 |
| Q3 | 71.4 |
| 95-th percentile | 1533 |
| Maximum | 49409.36 |
| Range | 49409.36 |
| Interquartile range (IQR) | 63.8 |
Descriptive statistics
| Standard deviation | 1367.93726 |
|---|---|
| Coefficient of variation (CV) | 4.404705505 |
| Kurtosis | 189.0219014 |
| Mean | 310.5627059 |
| Median Absolute Deviation (MAD) | 478.1886963 |
| Skewness | 11.082327 |
| Sum | 33911894.67 |
| Variance | 1871252.348 |
| Value | Count | Frequency (%) | |
| 0 | 1632 | 1.5% | |
| 4.8 | 1280 | 1.2% | |
| 4.2 | 1095 | 1.0% | |
| 15.3 | 766 | 0.7% | |
| 3.3 | 734 | 0.7% | |
| 8.7 | 717 | 0.7% | |
| 6 | 700 | 0.6% | |
| 11.7 | 638 | 0.6% | |
| 5.7 | 576 | 0.5% | |
| 3 | 573 | 0.5% | |
| Other values (1906) | 100484 | 92.0% |
| Value | Count | Frequency (%) | |
| 0 | 1632 | 1.5% | |
| 0.03 | 63 | 0.1% | |
| 0.07 | 72 | 0.1% | |
| 0.09 | 89 | 0.1% | |
| 0.1 | 215 | 0.2% |
| Value | Count | Frequency (%) | |
| 49409.36 | 4 | < 0.1% | |
| 41212.53 | 1 | < 0.1% | |
| 35099.96 | 7 | < 0.1% | |
| 34752 | 1 | < 0.1% | |
| 30433.62 | 1 | < 0.1% |
Pure_OTC
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 80726 | 73.9% | |
| 1 | 28474 | 26.1% |
| Distinct count | 54 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.10550366 |
|---|---|
| Minimum | 0.0 |
| Maximum | 448.0 |
| Zeros | 1631 |
| Zeros (%) | 1.5% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 90 |
| Maximum | 448 |
| Range | 448 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 28.60742204 |
|---|---|
| Coefficient of variation (CV) | 1.238121551 |
| Kurtosis | 18.62121675 |
| Mean | 23.10550366 |
| Median Absolute Deviation (MAD) | 20.08078614 |
| Skewness | 2.857420108 |
| Sum | 2523121 |
| Variance | 818.3845959 |
| Value | Count | Frequency (%) | |
| 1 | 38992 | 35.7% | |
| 30 | 24328 | 22.3% | |
| 28 | 7331 | 6.7% | |
| 60 | 5654 | 5.2% | |
| 20 | 5458 | 5.0% | |
| 100 | 3641 | 3.3% | |
| 10 | 2629 | 2.4% | |
| 50 | 2455 | 2.2% | |
| 5 | 1958 | 1.8% | |
| 56 | 1846 | 1.7% | |
| Other values (44) | 14908 | 13.7% |
| Value | Count | Frequency (%) | |
| 0 | 1631 | 1.5% | |
| 1 | 38992 | 35.7% | |
| 2 | 1255 | 1.1% | |
| 3 | 799 | 0.7% | |
| 4 | 1409 | 1.3% |
| Value | Count | Frequency (%) | |
| 448 | 1 | < 0.1% | |
| 400 | 46 | < 0.1% | |
| 270 | 3 | < 0.1% | |
| 224 | 3 | < 0.1% | |
| 210 | 36 | < 0.1% |
| Distinct count | 55 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 1467 |
| Missing (%) | 1.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.42013125 |
|---|---|
| Minimum | 0.0 |
| Maximum | 448.0 |
| Zeros | 164 |
| Zeros (%) | 0.2% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 90 |
| Maximum | 448 |
| Range | 448 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 28.67333173 |
|---|---|
| Coefficient of variation (CV) | 1.224302777 |
| Kurtosis | 18.58325401 |
| Mean | 23.42013125 |
| Median Absolute Deviation (MAD) | 20.05709491 |
| Skewness | 2.850608592 |
| Sum | 2523121 |
| Variance | 822.1599527 |
| Value | Count | Frequency (%) | |
| 1 | 38992 | 35.7% | |
| 30 | 24328 | 22.3% | |
| 28 | 7331 | 6.7% | |
| 60 | 5654 | 5.2% | |
| 20 | 5458 | 5.0% | |
| 100 | 3641 | 3.3% | |
| 10 | 2629 | 2.4% | |
| 50 | 2455 | 2.2% | |
| 5 | 1958 | 1.8% | |
| 56 | 1846 | 1.7% | |
| Other values (44) | 13441 | 12.3% | |
| (Missing) | 1467 | 1.3% |
| Value | Count | Frequency (%) | |
| 0 | 164 | 0.2% | |
| 1 | 38992 | 35.7% | |
| 2 | 1255 | 1.1% | |
| 3 | 799 | 0.7% | |
| 4 | 1409 | 1.3% |
| Value | Count | Frequency (%) | |
| 448 | 1 | < 0.1% | |
| 400 | 46 | < 0.1% | |
| 270 | 3 | < 0.1% | |
| 224 | 3 | < 0.1% | |
| 210 | 36 | < 0.1% |
| Distinct count | 89 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 3430 |
| Missing (%) | 3.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.56672497 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1000.0 |
| Zeros | 73588 |
| Zeros (%) | 67.4% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 5 |
| 95-th percentile | 125 |
| Maximum | 1000 |
| Range | 1000 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 83.55999548 |
|---|---|
| Coefficient of variation (CV) | 3.268310493 |
| Kurtosis | 40.42127355 |
| Mean | 25.56672497 |
| Median Absolute Deviation (MAD) | 40.07850571 |
| Skewness | 5.583719107 |
| Sum | 2704192.5 |
| Variance | 6982.272844 |
| Value | Count | Frequency (%) | |
| 0 | 73588 | 67.4% | |
| 15 | 3639 | 3.3% | |
| 100 | 2884 | 2.6% | |
| 10 | 2528 | 2.3% | |
| 50 | 2375 | 2.2% | |
| 30 | 2283 | 2.1% | |
| 5 | 1815 | 1.7% | |
| 20 | 1412 | 1.3% | |
| 500 | 1201 | 1.1% | |
| 3 | 967 | 0.9% | |
| Other values (78) | 13078 | 12.0% | |
| (Missing) | 3430 | 3.1% |
| Value | Count | Frequency (%) | |
| 0 | 73588 | 67.4% | |
| 0.1 | 14 | < 0.1% | |
| 0.2 | 20 | < 0.1% | |
| 0.3 | 44 | < 0.1% | |
| 0.4 | 182 | 0.2% |
| Value | Count | Frequency (%) | |
| 1000 | 138 | 0.1% | |
| 750 | 70 | 0.1% | |
| 500 | 1201 | 1.1% | |
| 454 | 61 | 0.1% | |
| 450 | 148 | 0.1% |
| Distinct count | 2158 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 72244.11013 |
|---|---|
| Minimum | 0.0 |
| Maximum | 5242283.0 |
| Zeros | 11178 |
| Zeros (%) | 10.2% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 697 |
| median | 3116 |
| Q3 | 40883 |
| 95-th percentile | 295952 |
| Maximum | 5242283 |
| Range | 5242283 |
| Interquartile range (IQR) | 40186 |
Descriptive statistics
| Standard deviation | 287676.8711 |
|---|---|
| Coefficient of variation (CV) | 3.982011413 |
| Kurtosis | 149.9582291 |
| Mean | 72244.11013 |
| Median Absolute Deviation (MAD) | 103397.3879 |
| Skewness | 10.43211316 |
| Sum | 7889056826 |
| Variance | 8.275798214e+10 |
| Value | Count | Frequency (%) | |
| 0 | 11178 | 10.2% | |
| 1235 | 168 | 0.2% | |
| 1392 | 160 | 0.1% | |
| 461 | 149 | 0.1% | |
| 736 | 146 | 0.1% | |
| 1796 | 146 | 0.1% | |
| 49325 | 144 | 0.1% | |
| 1635 | 144 | 0.1% | |
| 143220 | 143 | 0.1% | |
| 13625 | 142 | 0.1% | |
| Other values (2148) | 96680 | 88.5% |
| Value | Count | Frequency (%) | |
| 0 | 11178 | 10.2% | |
| 1 | 24 | < 0.1% | |
| 3 | 41 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 22 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5242283 | 72 | 0.1% | |
| 5095219 | 72 | 0.1% | |
| 3274632 | 72 | 0.1% | |
| 2616084 | 72 | 0.1% | |
| 2266471 | 72 | 0.1% |
Seasonality
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 15 |
| Missing (%) | < 0.1% |
| Memory size | 853.2 KiB |
| no | |
|---|---|
| yes | 16914 |
| (Missing) | 15 |
| Value | Count | Frequency (%) | |
| no | 92271 | 84.5% | |
| yes | 16914 | 15.5% | |
| (Missing) | 15 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 109200 | 100.0% |
| Distinct count | 53 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 9531 |
| Missing (%) | 8.7% |
| Memory size | 853.2 KiB |
| TAB | |
|---|---|
| CAP | |
| CR | 5930 |
| COL | 3767 |
| CPL | 3095 |
| Other values (47) |
| Value | Count | Frequency (%) | |
| TAB | 44496 | 40.7% | |
| CAP | 10089 | 9.2% | |
| CR | 5930 | 5.4% | |
| COL | 3767 | 3.4% | |
| CPL | 3095 | 2.8% | |
| GEL | 2487 | 2.3% | |
| OIN | 2386 | 2.2% | |
| SOL | 2137 | 2.0% | |
| INJ | 1959 | 1.8% | |
| LIQ | 1921 | 1.8% | |
| Other values (42) | 21402 | 19.6% | |
| (Missing) | 9531 | 8.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.03297619 |
| Min length | 2 |
| Distinct count | 3281 |
|---|---|
| Unique (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 10000005285 | 72 |
|---|---|
| 10000003428 | 72 |
| 10000002589 | 72 |
| 10000005408 | 72 |
| 10000002681 | 72 |
| Other values (3276) |
| Value | Count | Frequency (%) | |
| 10000005285 | 72 | 0.1% | |
| 10000003428 | 72 | 0.1% | |
| 10000002589 | 72 | 0.1% | |
| 10000005408 | 72 | 0.1% | |
| 10000002681 | 72 | 0.1% | |
| 10000004917 | 72 | 0.1% | |
| 10000006948 | 72 | 0.1% | |
| 10000005390 | 72 | 0.1% | |
| 10000006378 | 72 | 0.1% | |
| 10000003484 | 72 | 0.1% | |
| Other values (3271) | 108480 | 99.3% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 11 |
|---|---|
| Mean length | 11 |
| Min length | 11 |
Sourcing_source
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| ארץ | |
|---|---|
| חו"ל | 667 |
| Value | Count | Frequency (%) | |
| ארץ | 108533 | 99.4% | |
| חו"ל | 667 | 0.6% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.006108059 |
| Min length | 3 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 109200 | 100.0% |
storecode
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| 3224 | |
|---|---|
| 3315 |
| Value | Count | Frequency (%) | |
| 3224 | 55436 | 50.8% | |
| 3315 | 53764 | 49.2% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 8884 |
| Missing (%) | 8.1% |
| Memory size | 853.2 KiB |
| 0 | |
|---|---|
| 1 | 399 |
| 3 | 70 |
| 2 | 19 |
| Value | Count | Frequency (%) | |
| 0 | 99828 | 91.4% | |
| 1 | 399 | 0.4% | |
| 3 | 70 | 0.1% | |
| 2 | 19 | < 0.1% | |
| (Missing) | 8884 | 8.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
TranQuantity
Real number (ℝ≥0)
| Distinct count | 2101 |
|---|---|
| Unique (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 196.1847253 |
|---|---|
| Minimum | 0.0 |
| Maximum | 12780.0 |
| Zeros | 546 |
| Zeros (%) | 0.5% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 20 |
| Q3 | 126 |
| 95-th percentile | 950 |
| Maximum | 12780 |
| Range | 12780 |
| Interquartile range (IQR) | 123 |
Descriptive statistics
| Standard deviation | 589.8659505 |
|---|---|
| Coefficient of variation (CV) | 3.006686426 |
| Kurtosis | 90.78169812 |
| Mean | 196.1847253 |
| Median Absolute Deviation (MAD) | 261.9104563 |
| Skewness | 7.862365333 |
| Sum | 21423372 |
| Variance | 347941.8396 |
| Value | Count | Frequency (%) | |
| 1 | 13075 | 12.0% | |
| 2 | 9063 | 8.3% | |
| 3 | 6368 | 5.8% | |
| 4 | 4917 | 4.5% | |
| 60 | 4242 | 3.9% | |
| 30 | 3960 | 3.6% | |
| 5 | 3585 | 3.3% | |
| 6 | 3013 | 2.8% | |
| 120 | 2453 | 2.2% | |
| 90 | 2226 | 2.0% | |
| Other values (2091) | 56298 | 51.6% |
| Value | Count | Frequency (%) | |
| 0 | 546 | 0.5% | |
| 1 | 13075 | 12.0% | |
| 2 | 9063 | 8.3% | |
| 3 | 6368 | 5.8% | |
| 4 | 4917 | 4.5% |
| Value | Count | Frequency (%) | |
| 12780 | 2 | < 0.1% | |
| 12420 | 1 | < 0.1% | |
| 12240 | 1 | < 0.1% | |
| 11460 | 2 | < 0.1% | |
| 11264 | 1 | < 0.1% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 102708 |
| Missing (%) | 94.1% |
| Memory size | 853.2 KiB |
| BOX | |
|---|---|
| TUB | |
| BOT | |
| PKG | 250 |
| BAG | 27 |
| Value | Count | Frequency (%) | |
| BOX | 4341 | 4.0% | |
| TUB | 932 | 0.9% | |
| BOT | 926 | 0.8% | |
| PKG | 250 | 0.2% | |
| BAG | 27 | < 0.1% | |
| KIT | 16 | < 0.1% | |
| (Missing) | 102708 | 94.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.940549451 |
| Min length | 3 |
| Distinct count | 34 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 107330 |
| Missing (%) | 98.3% |
| Memory size | 853.2 KiB |
| 01.03.2016 | 162 |
|---|---|
| 01.02.2018 | 141 |
| 01.10.2020 | 136 |
| 01.07.2018 | 130 |
| 01.10.2018 | 114 |
| Other values (28) |
| Value | Count | Frequency (%) | |
| 01.03.2016 | 162 | 0.1% | |
| 01.02.2018 | 141 | 0.1% | |
| 01.10.2020 | 136 | 0.1% | |
| 01.07.2018 | 130 | 0.1% | |
| 01.10.2018 | 114 | 0.1% | |
| 01.05.2020 | 108 | 0.1% | |
| 01.03.2017 | 98 | 0.1% | |
| 01.12.2019 | 87 | 0.1% | |
| 01.03.2020 | 82 | 0.1% | |
| 01.06.2018 | 78 | 0.1% | |
| Other values (23) | 734 | 0.7% | |
| (Missing) | 107330 | 98.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.102747253 |
| Min length | 4 |
| Distinct count | 83 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 103787 |
| Missing (%) | 95.0% |
| Memory size | 853.2 KiB |
| 28.02.2015 | 297 |
|---|---|
| 30.04.2015 | 296 |
| 30.11.2012 | 291 |
| 30.11.2013 | 216 |
| 31.01.2007 | 216 |
| Other values (77) |
| Value | Count | Frequency (%) | |
| 28.02.2015 | 297 | 0.3% | |
| 30.04.2015 | 296 | 0.3% | |
| 30.11.2012 | 291 | 0.3% | |
| 30.11.2013 | 216 | 0.2% | |
| 31.01.2007 | 216 | 0.2% | |
| 30.09.2012 | 170 | 0.2% | |
| 31.10.2013 | 144 | 0.1% | |
| 31.03.2015 | 143 | 0.1% | |
| 31.05.2014 | 138 | 0.1% | |
| 31.01.2008 | 134 | 0.1% | |
| Other values (72) | 3368 | 3.1% | |
| (Missing) | 103787 | 95.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 4.297417582 |
| Min length | 4 |
| Distinct count | 155 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 680 |
| Missing (%) | 0.6% |
| Memory size | 853.2 KiB |
| 400059 | 10422 |
|---|---|
| 400057 | 5992 |
| 408668 | 5839 |
| 400095 | 5065 |
| 400045 | 4310 |
| Other values (149) |
| Value | Count | Frequency (%) | |
| 400059 | 10422 | 9.5% | |
| 400057 | 5992 | 5.5% | |
| 408668 | 5839 | 5.3% | |
| 400095 | 5065 | 4.6% | |
| 400045 | 4310 | 3.9% | |
| 406885 | 4250 | 3.9% | |
| 407214 | 3381 | 3.1% | |
| 400026 | 3330 | 3.0% | |
| 410232 | 3310 | 3.0% | |
| 400032 | 2641 | 2.4% | |
| Other values (144) | 59980 | 54.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 5.987545788 |
| Min length | 4 |
volume
Real number (ℝ≥0)
| Distinct count | 1971 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 196.851421 |
|---|---|
| Minimum | 0.0 |
| Maximum | 9973.0 |
| Zeros | 64 |
| Zeros (%) | 0.1% |
| Memory size | 853.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.072 |
| Q1 | 6.239 |
| median | 84 |
| Q3 | 245.784 |
| 95-th percentile | 744 |
| Maximum | 9973 |
| Range | 9973 |
| Interquartile range (IQR) | 239.545 |
Descriptive statistics
| Standard deviation | 368.6860182 |
|---|---|
| Coefficient of variation (CV) | 1.872915199 |
| Kurtosis | 71.22447651 |
| Mean | 196.851421 |
| Median Absolute Deviation (MAD) | 206.2782965 |
| Skewness | 6.116605493 |
| Sum | 21496175.17 |
| Variance | 135929.38 |
| Value | Count | Frequency (%) | |
| 3.467 | 729 | 0.7% | |
| 3.5 | 620 | 0.6% | |
| 3.433 | 541 | 0.5% | |
| 3.967 | 500 | 0.5% | |
| 180 | 479 | 0.4% | |
| 7.333 | 406 | 0.4% | |
| 6.5 | 388 | 0.4% | |
| 3.6 | 384 | 0.4% | |
| 8.1 | 382 | 0.3% | |
| 99 | 372 | 0.3% | |
| Other values (1961) | 104399 | 95.6% |
| Value | Count | Frequency (%) | |
| 0 | 64 | 0.1% | |
| 0.226 | 3 | < 0.1% | |
| 0.778 | 14 | < 0.1% | |
| 0.91 | 72 | 0.1% | |
| 1.01 | 14 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9973 | 2 | < 0.1% | |
| 8258 | 13 | < 0.1% | |
| 4554 | 72 | 0.1% | |
| 4377 | 21 | < 0.1% | |
| 4326 | 65 | 0.1% |
Volume_marker
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 853.2 KiB |
| LOW | |
|---|---|
| HIGH |
| Value | Count | Frequency (%) | |
| LOW | 69153 | 63.3% | |
| HIGH | 40047 | 36.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.366730769 |
| Min length | 3 |
First rows
| A_group_of_materials | ABC | Affiliation_Group | Alternative_purchasing_group | ATC | Basic_unit_of_measure | Budget_Group | Chemical_/_biological | chronic | Consumer_management | consumption | consumption_previous_year | Current_consumption | Dangerous_material_is_charged_with_a_permit | dangerous_substance | Date_of_basket_entry | Description_Alternative_purchasing_group | Description_outline | Establishment_date_of_the_item | European_patent_expires | Exceptional_policy | For_adults | Form_of_giving | General_purpose | GENERY_FATHER | Inventory | Inventory_of_consumption_months | Item_in_health_basket | Item_Type | Loading_group | Main_outline | Material_Type | month_year | Must_prescribe | Narcotic_/_psychotropic | Plant | Prediction | PRICE | Price_for_absolute_packaging | Pure_OTC | Quantity_in_absolute_packaging | Quantity_in_Packaging-Absolute | Quantity_in_packing-relative | Safety_Stock | Seasonality | Send_code_to_Omri | Serving_form | skucode2 | Sourcing_source | status | storecode | Toxic_item | TranQuantity | type_of_packeging | U#S#_Patent_Expires | Validity_of_Ministry_of_Health_registration | VENDOR | volume | Volume_marker | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20140 | B | 15 | 1180 | ATC:G03AA09 | PAC | B | 1.0 | 0.0 | ave | 6369.0 | 83062.0 | 8491.0 | None | None | 01.04.2005 | Oral contraceptive | Oral Contra. | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | None | 8811.0 | 1.38 | 1.0 | 0.0 | 23 | 171 | ZHW1 | 03/2017 | 1.0 | 0.0 | 7350.0 | 7351.0 | 9.36 | 196.56 | 0.0 | 21.0 | 21.0 | 0.0 | 4671.0 | no | 1.0 | TAB | 10000005719 | ארץ | 1.0 | 3224.0 | 0.0 | 11.0 | BOX | None | None | 408668 | 101.000 | LOW |
| 1 | 20190 | C | 20 | 1054 | ATC:N06AA04 | EA | B | 1.0 | 1.0 | ave | 26450.0 | 306420.0 | 34920.0 | None | None | 01.01.1995 | Depression-Tricyclic | Antidepressants | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 3999005422 | 68550.0 | 2.59 | 1.0 | 0.0 | 23 | 420 | ZHW1 | 02/2019 | 1.0 | 0.0 | 7350.0 | 25312.0 | 0.21 | 6.30 | 0.0 | 30.0 | 30.0 | 0.0 | 31010.0 | no | 1.0 | TAB | 10000006427 | ארץ | 1.0 | 3224.0 | 0.0 | 120.0 | None | None | None | 400095 | 3.733 | LOW |
| 2 | 20270 | C | 24 | 1351 | ATC:D08AX08 | EA | E | 1.0 | 0.0 | ave | 1321.0 | 13544.0 | 2220.0 | 0 | 0 | None | חיטוי ידיים | cosmetics | 2016-05-18 | None | 0.0 | None | None | 0.0 | None | 875.0 | 0.66 | 0.0 | 0.0 | 23 | 392 | ZHW1 | 07/2017 | 0.0 | NaN | 7350.0 | 1231.0 | 14.04 | 14.04 | 1.0 | 1.0 | 1.0 | 500.0 | 924.0 | no | 1.0 | GEL | 10000001880 | ארץ | 1.0 | 3315.0 | 0.0 | 2.0 | None | None | None | 124207 | 941.000 | HIGH |
| 3 | 10200 | C | 72 | None | ZRP:102US01 | EA | D | NaN | 1.0 | ave | 0.0 | 0.0 | 0.0 | None | None | 01.03.2001 | None | None | 2006-03-06 | None | 0.0 | None | None | 0.0 | None | 0.0 | 0.00 | 1.0 | 0.0 | 23 | None | ZHW3 | 11/2018 | 1.0 | NaN | 7350.0 | 0.0 | 18.81 | 18.81 | 0.0 | 1.0 | 1.0 | 0.0 | 0.0 | no | 1.0 | None | 10000007355 | ארץ | 1.0 | 3315.0 | NaN | 5.0 | None | None | None | 400044 | 198.360 | HIGH |
| 4 | 20180 | C | 19 | 1156 | ATC:M01AH01 | EA | B | 1.0 | 0.0 | ave | 47073.0 | 525410.0 | 59330.0 | None | None | None | NSAIDS-COX 2 inhibtors | Rheum. Arth. | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 3999010655 | 87390.0 | 1.86 | 0.0 | 0.0 | 23 | 65 | ZHW1 | 02/2017 | 1.0 | 0.0 | 7350.0 | 45373.0 | 0.56 | 5.60 | 0.0 | 10.0 | 10.0 | 0.0 | 53858.0 | no | 1.0 | CAP | 10000006732 | ארץ | 1.0 | 3224.0 | 0.0 | 30.0 | None | None | None | 400077 | 10.500 | LOW |
| 5 | 20120 | B | 13 | 1605 | ATC:C08CA01 | EA | B | 1.0 | 1.0 | ave | 0.0 | 0.0 | 0.0 | None | None | 01.01.2000 | Calcium Chanell Blockers | Calcium Chanell Blockers | 2006-09-26 | None | 0.0 | None | None | 0.0 | 3999019172 | 0.0 | 0.00 | 1.0 | 0.0 | 23 | 431 | ZHW1 | 04/2017 | 1.0 | 0.0 | 7350.0 | 0.0 | 0.14 | 2.80 | 0.0 | 20.0 | 20.0 | 0.0 | 0.0 | no | 1.0 | TAB | 10000004522 | ארץ | 1.0 | 3315.0 | 0.0 | 3220.0 | None | None | None | 400059 | 6.300 | HIGH |
| 6 | 10150 | C | 72 | None | ZRP:102UB01 | EA | D | NaN | 1.0 | ave | 0.0 | 0.0 | 0.0 | None | None | 01.03.2001 | None | None | 2009-06-03 | None | 0.0 | None | None | 0.0 | None | 0.0 | 0.00 | 1.0 | 0.0 | 23 | None | ZHW3 | 03/2019 | 1.0 | NaN | 7350.0 | 0.0 | 32.83 | 0.00 | 0.0 | 0.0 | NaN | NaN | 0.0 | no | 1.0 | None | 10000003897 | ארץ | 1.0 | 3315.0 | NaN | 4.0 | None | None | None | 400044 | 548.625 | HIGH |
| 7 | 20220 | C | 22 | 1946 | ATC:S01XA30 | PAC | E | 1.0 | 0.0 | ave | 1429.0 | 17751.0 | 1852.0 | None | None | None | טיפות ליובש בעיניים | Artificial Tears | 2010-12-27 | None | 0.0 | None | None | 0.0 | None | 2952.0 | 2.07 | 0.0 | 0.0 | 23 | 128 | ZHW1 | 05/2018 | 0.0 | NaN | 7350.0 | 1490.0 | 25.74 | 823.68 | 1.0 | 32.0 | 32.0 | 0.9 | 1544.0 | no | 1.0 | COL | 10000003478 | ארץ | 1.0 | 3315.0 | 0.0 | 10.0 | None | None | None | 400006 | 505.000 | LOW |
| 8 | 20100 | B | 11 | 1354 | ATC:A01AB09 | EA | B | 1.0 | 0.0 | ave | 3480.0 | 39454.0 | 4049.0 | None | None | 01.01.1995 | טיפול אנטי פטרייתי | Fungal Inf, Oroph. | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | None | 2510.0 | 0.72 | 1.0 | 0.0 | 23 | 83 | ZHW1 | 01/2018 | 0.0 | 0.0 | 7350.0 | 3255.0 | 13.06 | 13.06 | 0.0 | 1.0 | 1.0 | 40.0 | 1740.0 | no | 1.0 | GEL | 10000006295 | ארץ | 1.0 | 3315.0 | 0.0 | 4.0 | None | None | 30.04.2012 | 117469 | 214.000 | LOW |
| 9 | 10100 | C | 24 | 1429 | ZRP:A21AD | EA | E | NaN | 0.0 | ave | 514.0 | 5821.0 | 712.0 | None | None | None | סד תמיכה ליד | None | 2006-03-06 | None | 0.0 | None | None | 0.0 | None | 1282.0 | 2.49 | 0.0 | 0.0 | 23 | None | ZHW3 | 05/2018 | 0.0 | NaN | 7350.0 | 482.0 | 29.25 | 29.25 | 1.0 | 1.0 | 1.0 | 0.0 | 607.0 | no | 1.0 | None | 10000006992 | ארץ | 1.0 | 3224.0 | NaN | 2.0 | None | None | None | 400123 | 773.000 | LOW |
Last rows
| A_group_of_materials | ABC | Affiliation_Group | Alternative_purchasing_group | ATC | Basic_unit_of_measure | Budget_Group | Chemical_/_biological | chronic | Consumer_management | consumption | consumption_previous_year | Current_consumption | Dangerous_material_is_charged_with_a_permit | dangerous_substance | Date_of_basket_entry | Description_Alternative_purchasing_group | Description_outline | Establishment_date_of_the_item | European_patent_expires | Exceptional_policy | For_adults | Form_of_giving | General_purpose | GENERY_FATHER | Inventory | Inventory_of_consumption_months | Item_in_health_basket | Item_Type | Loading_group | Main_outline | Material_Type | month_year | Must_prescribe | Narcotic_/_psychotropic | Plant | Prediction | PRICE | Price_for_absolute_packaging | Pure_OTC | Quantity_in_absolute_packaging | Quantity_in_Packaging-Absolute | Quantity_in_packing-relative | Safety_Stock | Seasonality | Send_code_to_Omri | Serving_form | skucode2 | Sourcing_source | status | storecode | Toxic_item | TranQuantity | type_of_packeging | U#S#_Patent_Expires | Validity_of_Ministry_of_Health_registration | VENDOR | volume | Volume_marker | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109190 | 20130 | C | 14 | 1519 | ATC:D02AC02 | EA | E | 1.0 | 0.0 | pred | 900.0 | 9426.0 | 1085.0 | None | None | None | תכשיר רחצה טיפולי - תינוקות | Dry Skin | 2010-06-09 | None | 0.0 | None | None | 0.0 | None | 1563.0 | 1.74 | 0.0 | 0.0 | 25 | 142 | ZHW1 | 06/2018 | 0.0 | NaN | 7350.0 | 951.0 | 30.14 | 30.14 | 1.0 | 1.0 | 1.0 | 500.0 | 760.0 | yes | 1.0 | OIL | 10000003622 | ארץ | 1.0 | 3315.0 | 0.0 | 2.0 | None | None | None | 400044 | 985.000 | HIGH |
| 109191 | 20160 | A | 17 | 1651 | ATC:J07AJ52 | EA | B | 2.0 | 0.0 | pred | 0.0 | 0.0 | 0.0 | None | None | None | DPT Vac. | DPT Vac. | 2011-03-22 | None | 1.0 | None | None | 0.0 | 3999002140 | 0.0 | 0.00 | 1.0 | 0.0 | 11 | 96 | ZHW1 | 01/2017 | 1.0 | NaN | 7350.0 | 0.0 | 63.18 | 63.18 | 0.0 | 1.0 | 1.0 | 0.5 | 0.0 | no | 1.0 | SRG | 10000003406 | ארץ | 1.0 | 3315.0 | 0.0 | 0.0 | None | None | None | 400164 | 159.600 | LOW |
| 109192 | 20240 | B | 24 | 1401 | ATC:V06DB15 | EA | B | 1.0 | 0.0 | ave | 15000.0 | 196110.0 | 19770.0 | None | None | 01.03.2008 | מזון ייעודי | Metab. Disord. | 2014-11-04 | None | 0.0 | None | None | 0.0 | None | 10860.0 | 0.72 | 1.0 | 0.0 | 25 | 107 | ZHW1 | 04/2019 | 0.0 | NaN | 7350.0 | 16335.0 | 9.01 | 9.01 | 1.0 | 1.0 | 1.0 | 220.0 | 8916.0 | no | 1.0 | LIQ | 10000002408 | ארץ | 1.0 | 3315.0 | 0.0 | 60.0 | None | None | None | 401882 | 465.100 | HIGH |
| 109193 | 20180 | B | 19 | 1076 | ATC:M04AC01 | EA | B | 1.0 | 1.0 | ave | 463260.0 | 5311080.0 | 619170.0 | None | None | 01.01.1995 | FMF | Gout | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | None | 338070.0 | 0.73 | 1.0 | 0.0 | 23 | 75 | ZHW1 | 01/2017 | 1.0 | 5.0 | 7350.0 | 451081.0 | 0.35 | 10.50 | 0.0 | 30.0 | 30.0 | 0.0 | 231630.0 | no | 1.0 | TAB | 10000006474 | ארץ | 1.0 | 3224.0 | 0.0 | 1300.0 | None | None | None | 400045 | 2.933 | HIGH |
| 109194 | 20190 | C | 20 | 1639 | ATC:N06AX26 | EA | B | 1.0 | 1.0 | ave | 8727.0 | 95368.0 | 12180.0 | 0 | 0 | None | Depression | Depression | 2016-05-16 | None | 0.0 | None | None | 0.0 | None | 19376.0 | 2.22 | 0.0 | 0.0 | 23 | 11 | ZHW1 | 11/2019 | 1.0 | NaN | 7350.0 | 8732.0 | 4.22 | 118.16 | 0.0 | 28.0 | 28.0 | 0.0 | 9567.0 | no | 1.0 | TAB | 10000001890 | ארץ | 1.0 | 3224.0 | 0.0 | 28.0 | None | None | None | 401952 | 3.429 | LOW |
| 109195 | 20190 | C | 20 | 1823 | ATC:N02AA05 | EA | B | 1.0 | 0.0 | ave | 693.0 | 8445.0 | 861.0 | None | None | None | Pain, Mod/Sev | Pain, Mod/Sev | 2013-10-14 | None | 0.0 | None | None | 0.0 | None | 812.0 | 1.17 | 0.0 | 0.0 | 13 | 59 | ZHW1 | 03/2018 | 1.0 | 1.0 | 7350.0 | 731.0 | 32.76 | 32.76 | 0.0 | 1.0 | 1.0 | 30.0 | 778.0 | no | 1.0 | SYR | 10000002704 | ארץ | 1.0 | 3315.0 | 0.0 | 4.0 | None | None | None | 400045 | 168.000 | LOW |
| 109196 | 20130 | C | 14 | 1352 | ATC:D08AG02 | EA | B | 1.0 | 0.0 | pred | 6112.0 | 74934.0 | 6830.0 | None | None | 01.01.1995 | חיטוי נגעים בעור | Antiseptic | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 3999021150 | 5258.0 | 0.86 | 1.0 | 0.0 | 23 | 135 | ZHW1 | 03/2018 | 0.0 | 0.0 | 7350.0 | 4924.0 | 3.51 | 3.51 | 0.0 | 1.0 | 1.0 | 15.0 | 3447.0 | yes | 1.0 | OIN | 10000006784 | ארץ | 1.0 | 3315.0 | 0.0 | 19.0 | None | None | None | 400057 | 138.000 | HIGH |
| 109197 | 20100 | C | 11 | 1375 | ATC:A07BB01 | EA | B | 1.0 | 0.0 | ave | 69973.0 | 637500.0 | 116040.0 | None | None | 01.01.1995 | טיפול בשלשול וכאב בטן | Diarrhea | 2013-07-01 | None | 0.0 | None | None | 0.0 | 3999002540 | 99960.0 | 1.43 | 1.0 | 0.0 | 23 | 47 | ZHW1 | 06/2019 | 0.0 | NaN | 7350.0 | 53466.0 | 0.29 | 5.80 | 0.0 | 20.0 | 20.0 | 0.0 | 81947.0 | no | 1.0 | TAB | 10000002793 | ארץ | 1.0 | 3315.0 | 0.0 | 240.0 | None | None | None | 400026 | 6.050 | LOW |
| 109198 | 20150 | C | 16 | 1694 | ATC:H02AB07 | EA | B | 1.0 | 1.0 | ave | 169400.0 | 1913000.0 | 221300.0 | None | None | 01.01.1995 | Glucocorticoid | Glucocorticoid | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | None | 202900.0 | 1.20 | 1.0 | 0.0 | 23 | 141 | ZHW1 | 09/2017 | 1.0 | 0.0 | 7350.0 | 162085.0 | 0.15 | 15.00 | 0.0 | 100.0 | 100.0 | 0.0 | 180690.0 | no | 1.0 | TAB | 10000006612 | ארץ | 1.0 | 3224.0 | 0.0 | 300.0 | None | None | None | 400057 | 0.910 | LOW |
| 109199 | 20220 | B | 22 | 1082 | ATC:S01EA05 | EA | A | 1.0 | 1.0 | ave | 9242.0 | 108414.0 | 12071.0 | None | None | 01.10.2005 | Glaucoma alpha 2 agonist | Glaucoma | 2006-03-06 | None | 0.0 | None | 0 | 0.0 | 3999001444 | 6359.0 | 0.69 | 1.0 | 0.0 | 23 | 15 | ZHW1 | 09/2019 | 1.0 | 0.0 | 7350.0 | 8783.0 | 16.38 | 16.38 | 0.0 | 1.0 | 1.0 | 5.0 | 4621.0 | no | 1.0 | COL | 10000005869 | ארץ | 1.0 | 3315.0 | 0.0 | 40.0 | None | None | None | 400036 | 82.000 | LOW |